object frmShowStock: TfrmShowStock
  Left = 0
  Top = 0
  ClientHeight = 538
  ClientWidth = 1000
  Caption = #24211#23384
  OldCreateOrder = False
  MonitoredKeys.Keys = <>
  OnCreate = UniFormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object UniToolBar1: TUniToolBar
    Left = 0
    Top = 0
    Width = 1000
    Height = 45
    Hint = ''
    ButtonHeight = 45
    ButtonWidth = 60
    ShowCaptions = True
    TabOrder = 0
    ParentColor = False
    Color = clBtnFace
    object tbQuery: TUniToolButton
      Left = 0
      Top = 0
      Hint = ''
      ImageIndex = 10
      Caption = #26597#35810
      TabOrder = 1
      OnClick = tbQueryClick
    end
    object UniToolButton2: TUniToolButton
      Left = 60
      Top = 0
      Width = 8
      Hint = ''
      Style = tbsSeparator
      Caption = 'UniToolButton2'
      TabOrder = 2
    end
    object tbOK: TUniToolButton
      Left = 68
      Top = 0
      Hint = ''
      ImageIndex = 7
      Caption = #30830#23450
      TabOrder = 4
      OnClick = tbOKClick
    end
    object UniToolButton4: TUniToolButton
      Left = 128
      Top = 0
      Width = 8
      Hint = ''
      Style = tbsSeparator
      Caption = 'UniToolButton4'
      TabOrder = 5
    end
    object tbClose: TUniToolButton
      Left = 136
      Top = 0
      Hint = ''
      ImageIndex = 41
      Caption = #20851#38381
      TabOrder = 3
      OnClick = tbCloseClick
    end
  end
  object UniPanel2: TUniPanel
    Left = 0
    Top = 150
    Width = 1000
    Height = 388
    Hint = ''
    Align = alClient
    TabOrder = 1
    Caption = ''
    object UniDBGridBrowse: TUniDBGrid
      Left = 1
      Top = 1
      Width = 998
      Height = 386
      Hint = ''
      RowEditor = True
      DataSource = dsstk_mst
      ReadOnly = True
      LoadMask.Message = 'Loading data...'
      Align = alClient
      TabOrder = 1
      OnDblClick = UniDBGridBrowseDblClick
      Columns = <
        item
          FieldName = 'wh_name'
          Title.Alignment = taCenter
          Title.Caption = #20179#24211#21517#31216
          Width = 100
          ReadOnly = True
        end
        item
          FieldName = 'whd_name'
          Title.Alignment = taCenter
          Title.Caption = #20179#20301#21517#31216
          Width = 100
          ReadOnly = True
        end
        item
          FieldName = 'stk_part_no'
          Title.Alignment = taCenter
          Title.Caption = #20135#21697#32534#21495
          Width = 100
          ReadOnly = True
        end
        item
          FieldName = 'stk_part_desc1'
          Title.Alignment = taCenter
          Title.Caption = #20135#21697#21517#31216
          Width = 200
          ReadOnly = True
        end
        item
          FieldName = 'stk_part_desc2'
          Title.Alignment = taCenter
          Title.Caption = #35268#26684#22411#21495
          Width = 120
          ReadOnly = True
        end
        item
          FieldName = 'stk_val_qty'
          Title.Alignment = taCenter
          Title.Caption = #26377#25928#24211#23384
          Width = 80
          ReadOnly = True
        end
        item
          FieldName = 'stk_qty'
          Title.Alignment = taCenter
          Title.Caption = #24211#23384#25968#37327
          Width = 80
          ReadOnly = True
        end
        item
          FieldName = 'stk_ship_qty'
          Title.Alignment = taCenter
          Title.Caption = #24050#22791#36135#25968#37327
          Width = 80
          ReadOnly = True
        end
        item
          FieldName = 'stk_site_flags'
          Title.Alignment = taCenter
          Title.Caption = #32452#32455
          Width = 64
          ReadOnly = True
        end
        item
          FieldName = 'stk_vol'
          Title.Alignment = taCenter
          Title.Caption = #20307#31215
          Width = 80
          ReadOnly = True
        end
        item
          FieldName = 'stk_wts'
          Title.Alignment = taCenter
          Title.Caption = #37325#37327
          Width = 80
          ReadOnly = True
        end
        item
          FieldName = 'stk_part_desc3'
          Title.Alignment = taCenter
          Title.Caption = #25551#36848'3'
          Width = 150
          ReadOnly = True
        end
        item
          FieldName = 'stk_part_unit'
          Title.Alignment = taCenter
          Title.Caption = #21333#20301
          Width = 50
          ReadOnly = True
        end
        item
          FieldName = 'stk_part_vol'
          Title.Alignment = taCenter
          Title.Caption = #20135#21697#20307#31215
          Width = 80
          ReadOnly = True
        end
        item
          FieldName = 'stk_part_wts'
          Title.Alignment = taCenter
          Title.Caption = #20135#21697#37325#37327
          Width = 80
          ReadOnly = True
        end
        item
          FieldName = 'stk_uptime'
          Title.Alignment = taCenter
          Title.Caption = #26356#26032#26102#38388
          Width = 120
          ReadOnly = True
        end>
    end
  end
  object UniPanel1: TUniPanel
    Left = 0
    Top = 45
    Width = 1000
    Height = 105
    Hint = ''
    Align = alTop
    TabOrder = 2
    Caption = ''
    object UniLabel1: TUniLabel
      Left = 40
      Top = 45
      Width = 24
      Height = 13
      Hint = ''
      Caption = #20179#24211
      TabOrder = 1
    end
    object UniLabel2: TUniLabel
      Left = 40
      Top = 75
      Width = 24
      Height = 13
      Hint = ''
      Caption = #20179#20301
      TabOrder = 2
    end
    object UniLabel3: TUniLabel
      Left = 40
      Top = 15
      Width = 24
      Height = 13
      Hint = ''
      Caption = #32452#32455
      TabOrder = 3
    end
    object UniLabel9: TUniLabel
      Left = 216
      Top = 45
      Width = 48
      Height = 13
      Hint = ''
      Caption = #20135#21697#21517#31216
      TabOrder = 4
    end
    object UniLabel10: TUniLabel
      Left = 416
      Top = 41
      Width = 48
      Height = 13
      Hint = ''
      Caption = #35268#26684#22411#21495
      TabOrder = 5
    end
    object UniLabel12: TUniLabel
      Left = 428
      Top = 11
      Width = 30
      Height = 13
      Hint = ''
      Caption = #25551#36848'3'
      TabOrder = 6
    end
    object UniLabel16: TUniLabel
      Left = 216
      Top = 15
      Width = 48
      Height = 13
      Hint = ''
      Caption = #20135#21697#32534#21495
      TabOrder = 7
    end
    object edWhName: TUniEdit
      Left = 70
      Top = 40
      Width = 100
      Hint = ''
      Text = ''
      TabOrder = 8
    end
    object edWhdName: TUniEdit
      Left = 70
      Top = 70
      Width = 100
      Hint = ''
      Text = ''
      TabOrder = 9
    end
    object cbxSiteFlags: TUniComboBox
      Left = 70
      Top = 10
      Width = 100
      Hint = ''
      Style = csDropDownList
      Text = ''
      TabOrder = 10
      IconItems = <>
    end
    object edPartno: TUniEdit
      Left = 270
      Top = 10
      Width = 100
      Hint = ''
      Text = ''
      TabOrder = 11
    end
    object edPartDesc1: TUniEdit
      Left = 270
      Top = 40
      Width = 100
      Hint = ''
      Text = ''
      TabOrder = 12
    end
    object edPartDesc3: TUniEdit
      Left = 470
      Top = 6
      Width = 100
      Hint = ''
      Text = ''
      TabOrder = 13
    end
    object edPartDesc2: TUniEdit
      Left = 470
      Top = 36
      Width = 100
      Hint = ''
      Text = ''
      TabOrder = 14
    end
  end
  object dsstk_mst: TDataSource
    DataSet = zqstk_mst
    Left = 216
    Top = 280
  end
  object zqstk_mst: TZQuery
    Connection = UniMainModule.zDB
    ReadOnly = True
    SQL.Strings = (
      
        'select S.*, S.stk_qty - coalesce(S.stk_ship_qty,0) as stk_val_qt' +
        'y,'
      '    wh_no, wh_name, wh_site_flags, whd_name, whd_site_flags'
      'from stk_mst as S'
      '  left join wh_mst as WH'
      '    on S.stk_wh_snowflake = WH.wh_snowflake'
      '  left join whd_det as WHD'
      '    on S.stk_whd_snowflake = WHD.whd_snowflake')
    Params = <>
    Left = 216
    Top = 224
    object zqstk_mststk_snowflake: TLargeintField
      FieldName = 'stk_snowflake'
      ReadOnly = True
    end
    object zqstk_mststk_wh_snowflake: TLargeintField
      FieldName = 'stk_wh_snowflake'
      ReadOnly = True
    end
    object zqstk_mststk_whd_snowflake: TLargeintField
      FieldName = 'stk_whd_snowflake'
      ReadOnly = True
    end
    object zqstk_mststk_part_snowflake: TLargeintField
      FieldName = 'stk_part_snowflake'
      ReadOnly = True
    end
    object zqstk_mstwh_no: TWideStringField
      DisplayLabel = #20179#24211#32534#21495
      FieldName = 'wh_no'
      ReadOnly = True
      Size = 16
    end
    object zqstk_mstwh_name: TWideStringField
      DisplayLabel = #20179#24211#21517#31216
      FieldName = 'wh_name'
      ReadOnly = True
      Size = 32
    end
    object zqstk_mstwhd_name: TWideStringField
      DisplayLabel = #20179#20301#21517#31216
      FieldName = 'whd_name'
      ReadOnly = True
      Size = 32
    end
    object zqstk_mststk_site_flags: TIntegerField
      DisplayLabel = #32452#32455
      FieldName = 'stk_site_flags'
      ReadOnly = True
    end
    object zqstk_mststk_part_site_flags: TIntegerField
      DisplayLabel = #20135#21697#32452#32455
      FieldName = 'stk_part_site_flags'
      ReadOnly = True
    end
    object zqstk_mststk_part_no: TWideStringField
      DisplayLabel = #20135#21697#32534#21495
      FieldName = 'stk_part_no'
      ReadOnly = True
      Size = 24
    end
    object zqstk_mststk_part_desc1: TWideStringField
      DisplayLabel = #20135#21697#21517#31216
      FieldName = 'stk_part_desc1'
      ReadOnly = True
      Size = 64
    end
    object zqstk_mststk_part_desc2: TWideStringField
      DisplayLabel = #35268#26684#22411#21495
      FieldName = 'stk_part_desc2'
      ReadOnly = True
      Size = 64
    end
    object zqstk_mststk_part_desc3: TWideStringField
      DisplayLabel = #25551#36848'3'
      FieldName = 'stk_part_desc3'
      ReadOnly = True
      Size = 64
    end
    object zqstk_mststk_part_unit: TWideStringField
      DisplayLabel = #21333#20301
      FieldName = 'stk_part_unit'
      ReadOnly = True
      Size = 8
    end
    object zqstk_mststk_part_vol: TFloatField
      DisplayLabel = #20135#21697#20307#31215
      FieldName = 'stk_part_vol'
      ReadOnly = True
    end
    object zqstk_mststk_part_wts: TFloatField
      DisplayLabel = #20135#21697#37325#37327
      FieldName = 'stk_part_wts'
      ReadOnly = True
    end
    object zqstk_mststk_part_calc_class: TWideStringField
      DisplayLabel = #36731'/'#37325#36135
      FieldName = 'stk_part_calc_class'
      ReadOnly = True
      Size = 3
    end
    object zqstk_mststk_part_pack_qty: TIntegerField
      DisplayLabel = #21253#35013#25968#37327
      FieldName = 'stk_part_pack_qty'
      ReadOnly = True
    end
    object zqstk_mststk_part_card_qty: TIntegerField
      DisplayLabel = #21345#26495#25968#37327
      FieldName = 'stk_part_card_qty'
      ReadOnly = True
    end
    object zqstk_mststk_qty: TIntegerField
      DisplayLabel = #24211#23384#25968#37327
      FieldName = 'stk_qty'
      ReadOnly = True
      DisplayFormat = '###,#0'
    end
    object zqstk_mststk_vol: TFloatField
      DisplayLabel = #20307#31215
      FieldName = 'stk_vol'
      ReadOnly = True
      DisplayFormat = '###,#0.00'
    end
    object zqstk_mststk_wts: TFloatField
      DisplayLabel = #37325#37327
      FieldName = 'stk_wts'
      ReadOnly = True
      DisplayFormat = '###,#0.00'
    end
    object zqstk_mststk_ship_qty: TIntegerField
      DisplayLabel = #24050#22791#36135#25968#37327
      FieldName = 'stk_ship_qty'
      ReadOnly = True
      DisplayFormat = '###,#0'
    end
    object zqstk_mststk_val_qty: TIntegerField
      DisplayLabel = #26377#25928#24211#23384
      FieldName = 'stk_val_qty'
      ReadOnly = True
      DisplayFormat = '###,#0'
    end
    object zqstk_mststk_uptime: TDateTimeField
      DisplayLabel = #26356#26032#26102#38388
      FieldName = 'stk_uptime'
      ReadOnly = True
    end
  end
end
